Skip Headers

Oracle® Database Platform Guide 10g Release 2 (10.2) for Microsoft Windows (x64) Part Number B15688-02 |
Home | Book List | Contents | Master Index | Feedback

Previous | Next
| View PDF

Beta Draft

# D Error Messages on Windows

This appendix lists error messages, causes, and corrective actions that are specific to operation of Oracle Database for Windows. This appendix also includes database connection issues.

This appendix contains these topics:

- ORA-09275: CONNECT INTERNAL No Longer Supported

- OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages

- DIM-00000 to DIM-00039: ORADIM Command Syntax Errors

- Database Connection Issues

  Note: The `ora.hlp` file, which was shipped in previous releases, is no longer available. See this Appendix, Oracle Database Error Messages, and Oracle Enterprise Manager Messages Manual for information on error messages.

## D.1 ORA-09275: CONNECT INTERNAL No Longer Supported

ORA-09275
  Connect internal is not a valid DBA connection
  Cause: `CONNECT INTERNAL` is no longer supported.
  Action: If NTS is enabled, you can connect to the database as `CONNECT / AS SYSDBA`. If NTS is not enabled, you can connect as `CONNECT SYS/password AS SYSDBA`. You can also connect as an existing user with the appropriate password.

## D.2 OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages

Error messages in this section are Oracle Database operating system-dependent (OSD) messages displayed in response to an error condition in Windows. Each message in this section triggers an Oracle Database error message.

Error messages appear first in summary tables consisting of error numbers and the corresponding error message. Following the tables is a more detailed discussion of errors, including causes and corrective actions.

- File I/O Errors: OSD-04000 to OSD-04099

- Memory Errors: OSD-04100 to OSD-04199

- Process Errors: OSD-04200 to OSD-04299

- Loader Errors: OSD-04300 to OSD-04399

- Semaphore Errors: OSD-04400 to OSD-04499

- Miscellaneous Errors: OSD-04500 to OSD-04599

  File I/O Errors: | OSD-04000 to OSD-04099
  --- | ---
  4000 | Logical block size mismatch
  4001 | Invalid logical block size
  4002 | Unable to open file
  4003 | Unable to read file header block
  4004 | Invalid file header
  4005 | SetFilePointer() failure, unable to read from file
  4006 | ReadFile() failure, unable to read from file
  4007 | Truncated read
  4008 | WriteFile() failure, unable to write to file
  4009 | Truncated write
  4010 | <create> option specified, file already exists
  4011 | GetFileInformationByHandle() failure, unable to obtain file info
  4012 | File size mismatch
  4013 | Unable to read line from file
  4014 | Unable to close file
  4015 | An asynchronous I/O request returned an error
  4016 | Error queuing an asynchronous I/O request
  4017 | Unable to open the specified RAW device
  4018 | Unable to access the specified directory or device
  4019 | Unable to set file pointer
  4020 | Unable to set eof file marker
  4021 | Unable to read file
  4022 | Unable to write file
  4023 | SleepEx() failure, unable to Sleep
  4024 | Unable to delete file
  4025 | Invalid question asked
  4026 | Invalid parameter passed

  Memory Errors: | OSD-04100 to OSD-04199
  --- | ---
  4100 | malloc() failure, unable to allocate memory
  4101 | Invalid SGA: SGA not initialized
  4102 | Unable to open/create file for shared memory object
  4103 | Unable to attach to SGA: SGA does not exist
  4104 | Unable to map shared memory (SGA) into the address space
  4105 | Shared memory (SGA) mapped to wrong address
  4106 | Unable to allocate memory with VirtualAlloc
  4107 | Unable to deallocate memory with VirtualFree
  4108 | Unable to protect memory with VirtualProtect

  Process Errors: | OSD-04200 to OSD-04299
  --- | ---
  4200 | Unable to begin another thread
  4201 | No pid structure supplied to spdcr()
  4202 | DosSetPriority() failure, unable to set process priority
  4203 | DosKillProcess() failure, unable to kill process
  4204 | Invalid pid
  4205 | CreateProcess() failure, unable to spawn process
  4207 | Invalid priority specified in CONFIG parameter ORACLE_PRIORITY
  4208 | OpenProcess() failure, unable to open process handle
  4209 | Incorrect or unknown background image name given to spdcr()
  4210 | Timeout waiting for thread semaphore
  4211 | Thread information not found
  4212 | Maximum number of ORACLE threads reached
  4213 | ORACLE thread unable to DuplicateHandle()
  4214 | ORACLE thread unable to CreateEvent()
  4215 | Bad function code supplied to ssthreadop
  4216 | Unable to find file handle for that thread
  4217 | Unable to retrieve system username for current user
  4218 | Cannot post thread
  4219 | Bad thread list semaphore
  4221 | Target thread is currently busy
  4222 | Unable to get the threads context
  4223 | Unable to set the threads context
  4224 | Unable to suspend the target thread
  4225 | Unable to resume the target thread

  Loader Errors: | OSD-04300 to OSD-04399
  --- | ---
  4300 | Unable to read complete record from datafile
  4301 | Record size too large
  4302 | Invalid record type, load options, or both

  Semaphore Errors: | OSD-04400 to OSD-04499
  --- | ---
  4400 | Unable to acquire internal semaphore for process
  4401 | WaitForSingleObject() failure, unable to obtain semaphore

  Miscellaneous Errors: | OSD-04500 to OSD-04599
  --- | ---
  4500 | Illegal option specified
  4501 | Internal buffer overflow
  4502 | Translations nested too deep
  4503 | Text contains no translatable elements
  4505 | stdin not responding
  4506 | Unable to spawn process via system()
  4510 | Operating system roles are not supported
  4511 | Unable to get date and time from the operating system
  4512 | Unable to translate the 'USERNAME' config.ora variable on server
  4513 | 'remote_os_authent' init.ora variable not set to true
  4514 | The Windows Group name is too long for internal buffer
  4515 | This command is not implemented at this time

### D.2.1 File I/O Errors: OSD-04000 to OSD-04099

OSD-04000
  Logical block size mismatch
  Cause: Database block size specified in initialization parameter file does not match block size of actual database files.
  Action: Use matching logical block sizes.

OSD-04001
  Invalid logical block size
  Cause: Logical block size is not a multiple of 512 bytes, or it is too large.
  Action: Change the value of `DB_BLOCK_SIZE` in the initialization parameter file.

OSD-04002
  Unable to open file
  Cause: Specified path or filename is invalid, or destination device is full. This error can also be caused by insufficient Windows file handles.
  Action: Make sure path and file exist, and device has free space. If this fails, then increase number of Windows file handles.

OSD-04003
  Unable to read file header block
  Cause: Media has been damaged.
  Action: Recover file, if necessary, and verify that Windows is functioning correctly.

OSD-04004
  Invalid file header
  Cause: File is damaged.
  Action: Recover file.

OSD-04005
  SetFilePointer() failure, unable to read from file
  Cause: Unexpected return from Windows system service SetFilePointer().
  Action: Check operating system error code and operating system documentation.

OSD-04006
  ReadFile() failure, unable to read from file
  Cause: Unexpected return from Windows system service ReadFile().
  Action: Check operating system error code and operating system documentation.

OSD-04007
  Truncated read
  Cause: System encountered an unexpected end-of-file, which is due to damaged media.
  Action: Verify that file is not damaged.

OSD-04008
  WriteFile() failure, unable to write to file
  Cause: Unexpected return from Windows system service WriteFile().
  Action: Check operating system error code and operating system documentation.

OSD-04009
  Truncated write
  Cause: Destination device is full, or media is damaged.
  Action: Verify that device has free space and that file is not damaged.

OSD-04010
  <create> option specified, file already exists
  Cause: File you attempted to create already exists.
  Action: Delete existing file or use `REUSE` option in SQL statement.

OSD-04011
  GetFileInformationByHandle() failure, unable to obtain file info
  Cause: Unexpected return from Windows system service GetFileInformationByHandle().
  Action: Check operating system error code and operating system documentation.

OSD-04012
  File size mismatch
  Cause: File to be re-used is either too large or too small.
  Action: Specify correct file size or delete existing file.

OSD-04013
  Unable to read line from file
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04014
  Unable to close file
  Cause: Media has been damaged.
  Action: Recover file, if necessary, and verify that Windows is functioning correctly.

OSD-04015
  Asynchronous I/O request returned an error
  Cause: Unexpected return from Windows system service.
  Action: Check operating system error code and operating system documentation.

OSD-04016
  Error queuing an asynchronous I/O request
  Cause: Unexpected return from Windows system service.
  Action: Check operating system error code and operating system documentation.

OSD-04017
  Unable to open the specified RAW device
  Cause: An invalid path or filename was specified, or device is full.
  Action: Make sure file exists and device is not full; verify that operating system is functioning correctly.

OSD-04018
  Unable to access the specified directory or device
  Cause: An invalid path name was specified.
  Action: Make sure directory or device exists and is accessible.

OSD-04019
  Unable to set file pointer
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04020
  Unable to set eof file marker
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04021
  Unable to read file
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04022
  Unable to write file
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04023
  SleepEx() failure, unable to Sleep
  Cause: Unexpected return from Windows system service.
  Action: Check operating system error code and operating system documentation.

OSD-04024
  Unable to delete file
  Cause: This error is caused by an operating system error or by damaged media.
  Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.

OSD-04025
  Invalid question asked
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04026
  Invalid parameter passed
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

### D.2.2 Memory Errors: OSD-04100 to OSD-04199

OSD-04100
  Malloc() failure, unable to allocate memory
  Cause: Program is out of memory.
  Action: Shut down all unnecessary processes or install more memory in the computer.

OSD-04101
  Invalid SGA: SGA not initialized
  Cause: System Global Area (SGA) has been allocated but not initialized.
  Action: Wait until STARTUP has completed before attempting to connect.

OSD-04102
  Unable to open/create file for shared memory object
  Cause: Unexpected return from Windows system service CreateFile().
  Action: Check operating system error code and operating system documentation.

OSD-04103
  Unable to attach to SGA: SGA does not exist
  Cause: SGA does not exist.
  Action: Start up an Oracle Database instance.

OSD-04104
  Unable to map shared memory (SGA) into the address space
  Cause: Unexpected return from Windows system service MapViewOfFileEx().
  Action: Check operating system error code and operating system documentation.

OSD-04105
  Shared memory (SGA) mapped to wrong address
  Cause: Unexpected return from Windows system service MapViewOfFileEx().
  Action: Check operating system error code and operating system documentation.

OSD-04106
  Unable to allocate memory with VirtualAlloc
  Cause: Program is out of memory.
  Action: Shut down all unnecessary processes or install more memory in the computer.

OSD-04107
  Unable to deallocate memory with VirtualFree
  Cause: Unexpected return from Windows system service VirtualFree().
  Action: Check operating system error code and operating system documentation.

OSD-04108
  Unable to protect memory with VirtualProtect
  Cause: Unexpected return from Windows system service VirtualProtect().
  Action: Check operating system error code and operating system documentation.

### D.2.3 Process Errors: OSD-04200 to OSD-04299

OSD-04200
  Unable to begin another thread
  Cause: Program has run out of system resources.
  Action: Shut down all unnecessary processes; install more memory in the computer.

OSD-04201
  No pid structure supplied to spdcr()
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04202
  DosSetPriority() failure, unable to set process priority
  Cause: Unexpected return from Windows system service DosSetPriority().
  Action: Check operating system error code and operating system documentation.

OSD-04203
  DosKillProcess() failure, unable to kill process
  Cause: Unexpected return from Windows system service DosKillProcess().
  Action: Check operating system error code and operating system documentation.

OSD-04204
  Invalid pid
  Cause: Process ID not recognized by system; process previously terminated.
  Action: Verify that process ID is correct and that process is active.

OSD-04205
  CreateProcess() failure, unable to spawn process
  Cause: Unexpected return from Windows system service CreateProcess().
  Action: Check operating system error code and operating system documentation.

OSD-04207
  Invalid priority specified in CONFIG parameter `ORACLE_PRIORITY`
  Cause: Priority specified is invalid or out of range.
  Action: Specify a valid setting for `ORACLE_PRIORITY`.

OSD-04208
  OpenProcess() failure, unable to open process handle
  Cause: Unexpected return from Windows system service OpenProcess().
  Action: Check operating system error code and operating system documentation.

OSD-04209
  Incorrect or unknown background image name given to spdcr()
  Cause: Unexpected background name given to spdcr().
  Action: Contact Oracle Support Services.

OSD-04210
  Timeout waiting for thread semaphore
  Cause: An Oracle Database thread died holding the semaphore.
  Action: Restart Oracle Database instance.

OSD-04211
  Thread information not found
  Cause: An Oracle Database thread died without deleting its information.
  Action: Restart Oracle Database instance.

OSD-04212
  Maximum number of Oracle threads reached
  Cause: Maximum number of Oracle Database threads for the instance is reached.
  Action: Wait until some connections exit before trying again.

OSD-04213
  Oracle thread unable to DuplicateHandle()
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04214
  Oracle thread unable to CreateEvent()
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04215
  Bad function code supplied to ssthreadop
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04216
  Unable to find file handle for that thread
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04217
  Unable to retrieve system username for current user
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04218
  Cannot post thread
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04219
  Bad thread list semaphore
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04221
  Target thread is currently busy
  Cause: Target thread is processing an Oracle Database utility command.
  Action: Wait and resend command.

OSD-04222
  Unable to get the threads context
  Cause: Check operating system error code.
  Action: Remedy operating system error.

OSD-04223
  Unable to set the threads context
  Cause: Check operating system error code.
  Action: Remedy operating system error.

OSD-04224
  Unable to suspend the target thread
  Cause: Check operating system error code.
  Action: Remedy operating system error.

OSD-04225
  Unable to resume the target thread
  Cause: Check operating system error code.
  Action: Remedy operating system error.

### D.2.4 Loader Errors: OSD-04300 to OSD-04399

OSD-04300
  Unable to read complete record from datafile
  Cause: Datafile ended in the middle of a record. This error occurs when loading files with a fixed record length.
  Action: Verify that datafile is of correct length and contains complete records.

OSD-04301
  Record size too large
  Cause: Specified record size is too large to load.
  Action: Reduce record size and reload data.

OSD-04302
  Invalid record type, load options, or both
  Cause: Control file's Windows file processing options string contains an invalid option or keyword.
  Action: Set Windows file processing options string to an acceptable value.

### D.2.5 Semaphore Errors: OSD-04400 to OSD-04499

OSD-04400
  Unable to acquire internal semaphore for process
  Cause: Oracle Database has exceeded the maximum number of connections.
  Action: Delete any unused connections and try again.

OSD-04401
  WaitForSingleObject() failure, unable to obtain semaphore
  Cause: Unexpected return from Windows system service WaitForSingleObject().
  Action: Check operating system error code and operating system documentation.

### D.2.6 Miscellaneous Errors: OSD-04500 to OSD-04599

OSD-04500
  Illegal option specified
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04501
  Internal buffer overflow
  Cause: This is an internal error, not normally expected to occur.
  Action: Contact Oracle Support Services.

OSD-04502
  Translations nested too deep
  Cause: Program encountered too many intermediate translations while attempting to translate a configuration variable.
  Action: Simplify values of configuration parameters to include fewer intermediate translations.

OSD-04503
  Text contains no translatable elements
  Cause: Program cannot recognize variables in text to be translated.
  Action: Check and, if necessary, correct text to be translated.

OSD-04505
  stdin not responding
  Cause: System is unable to receive input from standard input stream.
  Action: Verify that process has access to an input device.

OSD-04506
  Unable to spawn process via system()
  Cause: System is out of memory or executable is invalid.
  Action: Shut down unnecessary processes; install more memory in the computer. Verify name of executable.

OSD-04510
  Operating system roles are not supported
  Cause: An attempt was made to use an operating system role.
  Action: Only use roles that were created '`IDENTIFIED` `BY` `PASSWORD`' as opposed to '`IDENTIFIED` `EXTERNALLY`'.

OSD-04511
  Unable to get date and time from the operating system
  Cause: Unexpected return from GetLocalTime() call.
  Action: Verify that system time is correct on the computer.

OSD-04512
  Unable to translate the '`USERNAME`' config.ora variable on server
  Cause: '`USERNAME`' configuration parameter variable on host is not properly set.
  Action: Verify '`USERNAME`' variable is set.

OSD-04513
  'remote_os_authent' init.ora variable not set to TRUE
  Cause: For remote operating system logon to function, '`REMOTE_OS_AUTHENT`' parameter must be set to `TRUE`.
  Action: Shut down and start up instance with '`REMOTE_OS_AUTHENT = TRUE`' in initialization parameter file.

OSD-04514
  The Windows Group name is too long for internal buffer
  Cause: Windows Group name is too long.
  Action: Use a shorter Windows group name.

## D.3 DIM-00000 to DIM-00039: ORADIM Command Syntax Errors

`ORADIM` is a command-line tool for starting and stopping database instances that is only available on Oracle Database for Windows. It is not available on any other platform.

Oradim Errors | DIM-0000 to DIM-0039
--- | ---
00000 | ORADIM completed with no errors
00001 | ORADIM: <command> [options]. Refer to manual.
00002 | The specified command was invalid.
00003 | An argument is missing for the parameter
00004 | SID or service name was not specified.
00005 | SID with more than 64 characters specified.
00006 | Missing SID
00007 | Missing or invalid `-`STARTMODE parameter. Valid `-`STARTMODE parameter is AUTO or MANUAL.
00008 | A valid service name is OracleService appended with a SID
00009 | SID name is mandatory.
00010 | `SYSTEM\CurrentControlSet\Services\OracleService` key does not exist.
00011 | The specified service does not exist.
00012 | A PFILE is necessary for AUTOSTART option.
00013 | Service start mode could not be set in the registry.
00014 | Cannot open the Windows Service Control Manager.
00015 | Cannot start already-running ORACLE - shut it down first.
00016 | Missing or invalid `-`SHUTTYPE parameter. A valid `-`SHUTTYPE parameter is SRVC or INST.
00017 | Instance shutdown mode must be one of the following: a for abort, i for immediate or n for normal.
00018 | Failed to stop Oracle Service.
00019 | Create Service Error.
00020 | A service for this name exists.
00021 | Registry open failed.
00023 | Create an instance by specifying the following options:
00024 | -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
00025 | [-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
00026 | [-SHUTMODE normal | immediate | abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
00027 | Edit an instance by specifying the following options:
00028 | -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
00029 | [-STARTMODE auto | manual] [SRVCSTART system | demand] [-PFILE file | -SPFILE]
00030 | [-SHUTMODE normal | immediate | abort] [-SHUTTYPE srvc | inst] [-RUNAS osusr/ospass]
00031 | Delete instances by specifying the following options:
00032 | -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
00033 | Startup services and instance by specifying the following options:
00034 | -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
00035 | [-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename | -SPFILE]
00036 | Shutdown services and instance by specifying the following options:
00037 | -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
00038 | [-SHUTTYPE srvc | inst | srvc,inst] [-SHUTMODE normal | immediate | abort]
00039 | Query for help by specifying the following parameters: -? | -h | -help
00040 | Invalid option for the -NEW command.
00041 | Invalid option for the -EDIT command.
00042 | Invalid option for the -DELETE command.
00043 | Invalid option for the -STARTUP command.
00044 | Invalid option for the -SHUTDOWN command.
00045 | Internal error in ORADIM.
00046 | Invalid Pfile.
00050 | Instance deleted.
00051 | Instance created.
00075 | Failed to control service.
00076 | Failed to delete service.
00077 | Failed to change service configuration.
00078 | Failed to start service.

DIM-00000
  ORADIM completed with no errors.
  Cause: The specified operation completed successfully.
  Action: None.

DIM-00001
  ORADIM: <command> [options]. Refer to manual.
  Cause: The specified options were invalid or no arguments were supplied.
  Action: Usage: ORADIM <command> [options]

DIM-00002
  The specified command was invalid.
  Cause: Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN.
  Action: Use valid command.

DIM-00003
  An argument is missing for the parameter.
  Cause: Missing or invalid argument.
  Action: Use a valid argument and invoke the program again.

DIM-00004
  SID or service name was not specified.
  Cause: Either a SID or service name is mandatory.
  Action: Enter a valid `SID` of 64 characters and retry.

DIM-00005
  SID with more than 64 characters specified.
  Cause: SID with more than 64 characters specified.
  Action: Change SID to 64 unique characters and make sure that there is no other service with this name.

DIM-00006
  Missing SID.
  Cause: SID was not specified in the arguments.
  Action: Specify a SID.

DIM-00007
  Missing or invalid -STARTMODE parameter. Valid -STARTMODE parameter is AUTO or MANUAL.
  Cause: An argument for STARTMODE is missing.
  Action: Enter a valid start mode and retry.

DIM-00008
  A valid service name is OracleService appended with a SID
  Cause: The Oracle service name specified is invalid.
  Action: Correct the name of service and retry.

DIM-00009
  SID name is mandatory.
  Cause: SID was not specified.
  Action: Enter the SID and retry.

DIM-00010
  SYSTEM\CurrentControlSet\Services\OracleService key does not exist.
  Cause: Specified registry key was not found.
  Action: Try reinstalling. If the problem persists, contact Oracle Support Services.

DIM-00011
  The specified service does not exist.
  Cause: An attempt to edit a service failed.
  Action: Make sure the service exists or user has enough privileges.

DIM-00012
  A PFILE is necessary for AUTOSTART option.
  Cause: A parameter file {PFILE} was not specified.
  Action: Specify a parameter file.

DIM-00013
  Service start mode could not be set in the registry.
  Cause: The start mode entry in the registry for the service could not be set.
  Action: Check if the user has privileges to modify registry.

DIM-00014
  Cannot open the Windows Service Control Manager.
  Cause: The Service Control Manager could not be opened.
  Action: Check for user privileges.

DIM-00015
  Cannot start already-running ORACLE - shut it down first.
  Cause: The instance is already started.
  Action: Stop the database before restarting.

DIM-00016
  Missing or invalid -SHUTTYPE parameter. A valid -SHUTTYPE parameter is SRVC or INST.
  Cause: An option for SHUTTYPE was missing or invalid.
  Action: Enter parameter to shut down the instance or the service and retry.

DIM-00017
  Instance shutdown mode must be one of the following: a for abort, i for immediate or n for normal.
  Cause: Invalid option to shut down the instance was specified.
  Action: Enter the correct mode and retry.

DIM-00018
  Failed to stop Oracle Service.
  Cause: An attempt to stop the service failed.
  Action: Retry, check for user privileges.

DIM-00019
  Create service error.
  Cause: Service could not be created.
  Action: Check for user privileges and retry.

DIM-00020
  A service for this name exists.
  Cause: An attempt was made to create a service name when it already existed.
  Action: Retry with a different service name or SID.

DIM-00021
  Registry open failed
  Cause: An attempt to open the registry failed.
  Action: Check for user privileges and retry the operation.

DIM-00023
  Create an instance by specifying the following options:
  Cause: n/a
  Action: n/a

DIM-00024
  -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
  Cause: n/a
  Action: n/a

DIM-00025
  [-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
  Cause: n/a
  Action: n/a

DIM-00026
  [-SHUTMODE normal | immediate | abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
  Cause: n/a
  Action: n/a

DIM00027
  Edit an instance by specifying the following options:
  Cause: n/a
  Action: n/a

DIM-00028
  -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
  Cause: n/a
  Action: n/a

DIM-00029
  [-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
  Cause: n/a
  Action: n/a

DIM-00030
  [-SHUTMODE normal | immediate | abort] [-SHUTTYPE srvc | inst] [-RUNAS osusr/ospass]
  Cause: n/a
  Action: n/a

DIM-00031
  Delete instances by specifying the following options:
  Cause: n/a
  Action: n/a

DIM-00032
  -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
  Cause: n/a
  Action: n/a

DIM-00033
  Start up services and instance by specifying the following options:
  Cause: n/a
  Action: n/a

DIM-00034
  -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
  Cause: n/a
  Action: n/a

DIM-00035
  [-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename | -SPFILE]
  Cause: n/a
  Action: n/a

DIM-00036
  Shut down services and instance by specifying the following options:
  Cause: n/a
  Action: n/a

DIM-00037
  -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
  Cause: n/a
  Action: n/a

DIM-00038
  [-SHUTTYPE srvc | inst | srvc,inst] [-SHUTMODE normal | immediate | abort]
  Cause: n/a
  Action: n/a

DIM-00039
  Query for help by specifying the following parameters: -? | -h | -help
  Cause: n/a
  Action: n/a

DIM-00040
  Invalid option for the -NEW command.
  Cause: One or more arguments for creating new service is invalid.
  Action: Specify required option and retry.

DIM-00041
  Invalid option for the -EDIT command.
  Cause: One or more arguments for editing existing service is invalid.
  Action: Specify required option and retry.

DIM-00042
  Invalid option for the -DELETE command.
  Cause: One or more arguments for deleting service is invalid.
  Action: Specify required option and retry.

DIM-00043
  Invalid option for the -STARTUP command.
  Cause: One or more arguments for starting the instance is invalid.
  Action: Specify required option and retry.

DIM-00044
  Invalid option for the -SHUTDOWN command.
  Cause: One or more arguments for shutting down the instance is invalid.
  Action: Specify required option and retry.

DIM-00045
  Internal error in ORADIM
  Cause: Unknown.
  Action: Contact Oracle Support Services.

DIM-00046
  Invalid Pfile.
  Cause: The parameter filename is invalid.
  Action: Check that the path name is correct.

DIM-00050
  Instance deleted
  Cause: The request for deleting instance was successful.
  Action: None.

DIM-00051
  Instance created.
  Cause: The request for creating new instance was successful.
  Action: None.

DIM-00075
  Failed to control service.
  Cause: An attempt to control the service failed.
  Action: Check additional error, make sure that user has enough privileges.

DIM-00076
  Failed to delete service.
  Cause: The request for service deletion failed.
  Action: Check additional error, make sure that user has enough privileges.

DIM-00077
  Failed to change service configuration.
  Cause: An attempt to change configuration failed.
  Action: Check additional error, make sure that user has enough privileges.

DIM-00078
  Failed to start service.
  Cause: The request to start service failed.
  Action: Check additional error, make sure that user has enough privileges.

## D.4 Database Connection Issues

The following are common Oracle Database connection error codes, their causes, and suggested remedies.

TNS-12203
  TNS: unable to connect to destination
  Cause: OracleServiceSID service, OracleHOME_NAMETNSListener service, or both are not running.
  Action: Ensure that both services are started.

ORA-12560
  TNS: lost contact
  Cause: OracleServiceSID service, OracleHOME_NAMETNSListener service, or both are not running. You receive this error if you attempt to use any Oracle Database utilities, such as SQL*Plus. This error is analogous to the following Oracle7 error: `ORA-09352:` `Windows` `32-bit` `Two-Task` `driver` `unable` `to spawn` `new` `ORACLE` `task`.
  Action: Ensure that both services are started.

ORA-28575
  unable to open RPC connection to external procedure agent
  Cause: `tnsnames.ora` and listener.ora files have not been correctly configured to use external procedures.
  Action: Reconfigure services.

ORA-06512
  at "APPLICATIONS.OSEXEC", line 0
  Cause: `tnsnames.ora` and listener.ora files have not been correctly configured to use external procedures.
  Action: Reconfigure services.

ORA-06512
  at "APPLICATIONS.TEST", line 4
  Cause: `tnsnames.ora` and `listener.ora` files have not been correctly configured to use external procedures.
  Action: Reconfigure services.

ORA-06512
  at line 2
  Cause: `tnsnames.ora` and `listener.ora` files have not been correctly configured to use external procedures.
  Action: Reconfigure services.

ORA-01031 and LCC-00161
  Both codes appear at startup
  Cause: Parameter file (init.ora) or Windows services are damaged. These errors usually appear when the parameter file cannot be read by Oracle Database at database startup.
  Action: Delete and re-create the SID and services. Make sure you are logged on as the user Administrator, or a user within the Windows Administrator's Group with full administrative rights. At the command prompt, enter: `oradim -delete -sid` `sid` where `sid` is the name of your database (for example, `orcl`). Re-create the SID and services by entering: `oradim -new -sid` `sid` `-startmode auto -pfile` `full_path_to_init.ora`